package com.guigu.erp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.guigu.erp.dto.DesignFileCountDto;
import com.guigu.erp.pojo.DesignFile;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import sun.security.krb5.internal.crypto.Des;

import java.util.List;
import java.util.Map;

public interface DesignFileMapper extends BaseMapper<DesignFile> {
    /**
     * 查询ID最大的产品档案信息
     * @return
     */
    DesignFile queryMaxFile();

    /**
     * 查询产品档案复核未审核的数量
     * @return
     */
    @Select("select count(*) from D_FILE where CHECK_TAG='S001-0' and DELETE_TAG='C001-0'")
    int queryCount();


    /**
     * 根据FactoryName统计产品档案
     * @return
     */
    List<DesignFileCountDto> countByFactoryName();
}
